Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 8 Forum

Notes/Domino 8 Forum
Previous Next
Subject: Calculate Outstanding Days
Feedback Type: Problem
Product Area: Designer Client
Technical Area: Application development
Platform: ALL
Release: All
Reproducible: Always

I'm trying to have a field that calculates how long a document hasn't been closed by a due date.
Field:
DueDate - Time\Date - Computed for Display
with value: @Adjust(DateRaised ; 0 ; 0 ; 30 ; 0 ; 0 ; 0 )
DateNow - Time\Date - Computed for Display
with value: @Now
DaysOS - Number - Computed for Display
with value: @IsNumber(DateNow-DueDate/864000)

The DaysOS field doesn't calculate the number of days, it only displays a zero. Before I added the @IsNumber I kept getting number expected error.

I have tried different combinations but just can't get it right.

Appreciate some help.
Marion


Feedback number WEBB95L62E created by ~Chloe Minnulitli on 03/08/2013

Status: Open
Comments:

Calculate Outstanding Days (~Chloe Minnulit... 8.Mar.13)
. . BODMAS (~Justin Chugero... 8.Mar.13)
. . . . Don't display negative value (~Chloe Minnulit... 12.Mar.13)
. . . . . . A couple of suggestions (~Justin Chugero... 14.Mar.13)
. . . . . . . . Great !! Thanks for your help (~Chloe Minnulit... 14.Mar.13)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS